{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Sheet1","Observations"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,1,21,11],[13,0,13,11],[19,0,19,11],[20,1,20,11],[9,0,9,10],[10,0,10,11],[16,1,16,11],[17,1,17,11],[14,1,14,11],[15,1,15,11],[11,1,11,11],[0,0,0,11],[1,0,1,3],[7,1,7,11],[2,1,2,11],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,1,6,11]]}
["How To Complete this form : "]
["Adding a defect/Observation:"]
[1,"To add a new Defect/observation:  select the \"Add New Observation\" button.\nThis will automatically insert a line onto the spreadsheet, after the last row containing a date"]
[2,"NOTE: The date needs to be completed in each row for the macro to run and this form to function."]
[3,"The vessel is to fill in all columns in light yellow ."]
[4,"The Ship Manager will review all defects and add his comments in the light blue columns."]
[5,"The vessel is to complete and close out the defect/observation. The ship closes out by means of updating the \"\"status\"\" column and the \"\"Date closed out\"\" column."]
[6,"The Ship Manager verifies he is satisfied with the closeout by means of \"\"X\"\" in the \"\"Close out Accepted\"\" column."]
[]
["I Want to:"]
["View only the defects/observations still open: "]
[1,"Press the \"\"Sort by status only\"\" and this will produce a list of Defects that have not \nbeen accepted by the Ship Manager as closed"]
[]
["Sort out open defects into person responsible (for their action): "]
[1,"Press the \"Status, Responsible Person, Priority and Target Date\" (in that order)"]
[2,"Columns D, E, J & M are drop down menus to ensure that the sort functions work correctly"]
[3,"To filter to only see observations that are open or for a specific person, select the down arrow in the relevant block. \n\n\n\nUntick the (Select All) button, and the select the rank that you wish to view.  Only ranks already listed with appear on the menu. \n\n"]
[4,"To clear the filter, select the \"Clear Filter\" option on the above menu."]
[]
["Returning the spreadsheet to show all observations - both open and closed: "]
[1,"To continue adding observations, the spreadsheet can be sorted back to numerical \norder by selecting the \"Sort S.No\" Button. "]
[2,"Before sorting, first clear all filters. This is required to ensure the S.No runs numerically, without duplication or omission, and that the new row is not \"hidden\" due to the filters."]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Observations","index":2,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,3,2],[0,12,0,13],[0,1,0,11],[2,1,2,2]]}
[null,"SAFETY, HEALTH, ENVIRONMENT AND QUALITY MANAGEMENT SYSTEM\n\nDEFECT MANAGEMENT FORM\n\n\nREPORTING FORMS MANUAL",null,null,null,null,null,null,null,null,null,null,"Form : 6.5.1\nDate : 11-Aug-25\nRev : 10.0\nApp By : DPA"]
[]
["VESSEL :",null,null,null,null,"DATE :"]
[]
["Date","S.No.","Description","Affected Codes (Marpol / Solas etc)","Status","Responsible\nPerson","Inspector Comment","Ship Manager's Comments","Ship's Comments","Requisition","Priority","Target date","Date closed","Close Out Accepted"]